select jobs.*,company_detail.company_name,company_detail.image,company_detail.company_background from jobs INNER JOIN company_detail ON jobs.employer_id = company_detail.employer_id where jobs.status='1' and jobs.location LIKE '%Abu Dhabhi%' OR jobs.city LIKE '%Abu Dhabhi%' order by jobs.created_at DESC
